package com.futu.scenicspot.mapper;

import com.futu.scenicspot.domain.HScenicImage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 86177
* @description 针对表【h_scenic_image(景点图片表)】的数据库操作Mapper
* @createDate 2025-06-10 17:37:11
* @Entity com.futu.scenicspot.domain.HScenicImage
*/
public interface HScenicImageMapper extends BaseMapper<HScenicImage> {
    
    /**
     * 根据景点ID查询图片列表
     * @param scenicId 景点ID
     * @return 图片列表
     */
    @Select("SELECT * FROM h_scenic_image WHERE scenic_id = #{scenicId} ORDER BY sort_order ASC, id ASC")
    List<HScenicImage> findByScenicId(@Param("scenicId") Long scenicId);
}




